Estrada Consulting Incorporated
Senior Data Architect / Data Engineer (Ref: 5601)
Sacramento, California•Contract
About the Job
Senior Data Architect / Data Engineer (Ref: 5601)
Location: Remote
Duration: 12 months
Location: Remote
Duration: 12 months
Mandatory qualifications:
- Four (4) or more years of relevant experience in authoring and monitoring data pipelines. Eight (8) years, if substituting bachelor’s or advanced degree for qualifying experience.
- Bachelor or advanced degree in computer science, engineering, information systems, math or technology-related field.
- Additional qualifying experience may be substituted for the required education on a year-for-year basis. Successful completion of a data engineering bootcamp plus an additional year of experience may be substituted for the degree requirement.
Additional Qualifications:
- Five (5) or more years of full-time equivalent (FTE) experience as a Senior Data Engineer in a lead role, responsible for modeling, architecting, developing, testing, deploying and supporting scalable, fault-tolerant data architectures to support enterprise decision making within Dimensional and other analytic data models (Data Warehouse, Data Mart)
- A minimum of four (4) years of extensive full-time equivalent (FTE) experience as a data pipeline engineer responsible for architecting, designing, developing/authoring, testing, deploying, monitoring and supporting scalable and fault-tolerant ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) solutions that move data – in near real-time and/or on a schedule - between on-premises and cloud infrastructure solution components using Microsoft SQL Server SSIS and Microsoft Azure Data Factory.
- A minimum of five (5) years of extensive full-time equivalent (FTE) experience architecting, designing, developing, testing, deploying and supporting data solutions within the Azure SQL, SQL MI, Azure Synapse, and/or Microsoft Fabric cloud platforms.
- A minimum of five (5) years of extensive full-time equivalent (FTE) experience developing solutions that include SQL scripting.
- A minimum of three (3) years of extensive full-time equivalent (FTE) experience developing analytic dashboards and reports within Microsoft PowerBI.
- A minimum of three (3) years of experience developing solutions that include Python components.
- A minimum of three (3) years of experience architecting, designing, developing, deploying, testing and supporting development of financial data analysis solution(s).
- A minimum of three (3) years of experience architecting, designing, developing, deploying, testing and supporting development of Healthcare Provider Network Adequacy analysis solution(s).
- A minimum of three (3) years of experience architecting, designing, developing, deploying, testing and supporting API driven bulk data integrations with Azure API Manager.
A minimum of two current Microsoft Certification(s) such as:
- Microsoft Fabric Analytics Engineer.
- Microsoft PowerBI Data Analyst.
- Microsoft Fabric Data Engineer.
- Microsoft Fabric Analytics Engineer.
- Microsoft Azure Data Enginee.
A minimum of one current Data Modeling Certification(s) such as:
- Microsoft Data Modeling in PowerBI.
- Certified Business Intelligence Leader (CBIL).
- Data Modeling Certification (DMI).
- CDMP Data Modeling Specialist (DMBOK).
About Estrada Consulting Incorporated
Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit http://www.estradaci.com/ to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.