Senior Data Engineer - Outsystems Project Experience (Ref: 5646)

• Senior Data Engineer with Outsystems project experience (Ref: 5646)
• Duration: 24 months
• Location: Remote within the Continental US
• Rate: DOE
• Degree copy and references is required for submission.

• A minimum of four (4) years of relevant experience in authoring and monitoring data pipelines.
• Eight (8) years, if substituting bachelor’s or advanced degree for additional qualifying experience.
• Possession of a bachelor’s or advanced degree (master’s or PhD) 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.

• Five (5) or more years of experience in working with data architects, business analysts, project management teams, developers and program/business stakeholders to develop, test, support and maintain hybrid cloud and on-premises Business Intelligence (BI) solutions including building, implementing and supporting data marts/warehouses, ETLs/ELTs, data pipelines, using Microsoft Azure BI platform.
• Five (5) or more years of experience in architecting, designing, creating and supporting on-premises and Azure SQL Server relational and dimensional databases.
• Five (5) or more years of experience in designing and creating data warehouses and data marts in on-premises and Microsoft Azure cloud platforms.
• Five (5) or more years of experience in dimensional and normalized relational data modeling.
• Five (5) or more years of experience in development using SQL Server, SQL, T/SQL.
• Five (5) or more years of experience in SQL performance tuning, analysis of execution plans, and database tuning.
• Five (5) or more years of experience in loading data warehouses and data marts from multiple data sources including data lakes.
• Five (5) or more years of experience in development and maintenance of data pipelines and ETL/ELT processes using SSIS, Azure Data Factory and Python.
• Five (5) or more years of experience in troubleshooting issues related with data and BI solutions in the Microsoft Azure Cloud environment.
• Three (3) or more years of experience developing and supporting reports and dashboards in SSRS, Power BI, and building Power BI data models.
• Possession of one (1) or more Microsoft Azure Data Engineering Associate Certification.
• Three (3) or more years of experience in documentation of code, data models, and creating ERD and data flow diagrams.
• Three (3) or more years of experience in loading data warehouses and data marts from OutSystems and Microsoft Power Apps/Dataverse.
• Three (3) or more years of experience developing solutions in ElasticSearch.

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.