ShiftCode Analytics, Inc. · 4 months ago
Data Engineer : Alpine Capital Research
St. Louis, MO
Full-time
Onsite
Mid LevelShiftCode Analytics, Inc. is a company focused on data solutions, and they are seeking a Data Engineer to design and maintain data pipelines. The role involves API integration, ETL development, and collaboration with project teams to ensure data integrity for business intelligence.
AnalyticsConsultingInformation Technology
No H1B
Responsibilities
Data Engineer responsible for designing, developing, and maintaining data pipelines and warehousing solutions
Key tasks will include API integration, ETL development, data modeling (Star Schema or Snowflake Schema), and supporting Power BI reporting
Will primarily work on the OIL Analytics Report Migration project initially, then transition to the Tamarac Data Warehouse project
Collaborate with internal project teams to ensure data accuracy, integrity, and structured organization for business intelligence
Qualification
Required
Data Engineer responsible for designing, developing, and maintaining data pipelines and warehousing solutions
Key tasks will include API integration, ETL development, data modeling (Star Schema or Snowflake Schema), and supporting Power BI reporting
Will primarily work on the OIL Analytics Report Migration project initially, then transition to the Tamarac Data Warehouse project
Collaborate with internal project teams to ensure data accuracy, integrity, and structured organization for business intelligence
Azure Synapse Analytics
Two separate environments (e.g., Development and Production)
Handles data warehousing and large-scale analytics workloads
Azure Data Lake
Centralized storage layer
Supports both structured and unstructured data
Scalable foundation for analytics and data integration
Azure Key Vault
Manages secrets, encryption keys, and certificates
Ensures secure access across both environments
Azure DevOps
CI/CD pipelines for automated builds and deployments
Manages data pipeline lifecycle and component delivery
Apache Spark Notebooks
Deployed in both environments
Used for interactive data exploration, transformation, and analytics
Azure Integration Runtime
Facilitates secure and scalable data movement
Enables transformations across network boundaries within Synapse or Data Factory
Metastore Data Warehouse
Centralized metadata repository
Maintains schema definitions, and table metadata
ARM Template (Azure Resource Manager)
Defines and automates infrastructure deployment
Enables consistent provisioning of Synapse, Data Lake, Key Vault, and other resources across environments
Company
ShiftCode Analytics, Inc.
ShiftCode Analytics Inc is a Tampa, FL based firm formed with one sole purpose of delivering best and quick services to its clients nationwide.
Founded in 2019
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase