Senior Data Solutions Engineer

Job Summary:

We are looking for an experienced technologist who is passionate about solving complex software and data challenges. In this role, you will collaborate with internal clients and team members to gather requirements, design data models, and provide innovative solutions. You will develop specifications, enhance processes, and support Enterprise Data & Analytics environments, including providing on-call support on a rolling calendar basis.

Key Responsibilities: Collaborate with cross-functional teams in various data domains to understand business requirements and provide data-driven recommendations. Design, develop, and maintain data models, data dictionaries, and scalable, reliable, and secure data solutions following industry best practices. Complete solution artifacts and documentation in accordance with requirements, seeking approval before commencing work. Manage data quality and integrity, promptly identifying and resolving data anomalies and inconsistencies. Perform project management tasks across projects of varying sizes. Mentor and provide guidance to junior IT colleagues in the ongoing development of the enterprise data cloud. Design, develop, and implement Power BI semantic models as required. Provide on-call support for enterprise data cloud applications on a rotating basis. Continuously strive to improve solution delivery processes and practices. Apply data profiling techniques to validate the structure, quality, and compliance of source data. Required Qualifications:

5+ years of hands-on experience in developing solutions for data engineering and analytic use cases. Bachelor's degree in Information Technology or a related specialty, or an equivalent combination of education and experience. Advanced knowledge of SQL languages, predominantly TSQL and PL/SQL. In-depth understanding of relational databases, data warehouse architecture, and dimensional database models (star schema). Advanced knowledge of information engineering concepts, including business system design, data modeling, security, and application construction. Ability to work effectively with technology staff, business stakeholders, end users, management, and external partners. Experience leading meetings with technical peers and upper management regarding data and analytics solutions. Strong organizational skills with the ability to manage multiple projects and meet deadlines in an agile work environment. Solid understanding of cloud data infrastructure, including Azure Data Factory, Azure Synapse, Microsoft Fabric, and Power BI. Proficient in big data technologies, such as Apache Spark, to process and handle large datasets. Familiarity with Data Lake, Serverless Architecture, and Delta Lake for implementing Lakehouse Architecture. Experience extracting data through REST and handling complex data structures ingested through REST. Working knowledge of Azure DevOps, including creating build and release pipelines, DACPAC deployment, YAML, and pull request/branch merging strategies. Good understanding of Power BI and Semantic Models. Knowledge of Azure Event Grid-based data movement frameworks.

Preferred Qualifications:

Any cloud certifications related to data (e.g., Azure, AWS, Google Cloud) are a plus.

Certifications (if any):

Cloud certifications related to data, such as Microsoft Certified: Azure Data Engineer Associate, are preferred.

Education:

Bachelors Degree