Role & Responsibilities:
- Design, develop, and maintain scalable data pipelines using Azure Data Factory, SQL, and Python.
- Build and optimize ETL/ELT processes across Microsoft-based cloud data platforms.
- Work with Microsoft Fabric to support modern analytics and data engineering workflows.
- Develop and maintain data models and transformation logic to support reporting and analytics needs.
- Collaborate with analysts, business stakeholders, and technical teams to translate business requirements into technical solutions.
- Support Power BI reporting needs by enabling clean, reliable, and well-structured datasets.
- Ensure data quality, consistency, and performance across ingestion, transformation, and reporting layers.
- Monitor and optimize workflows for reliability, scalability, and maintainability.
- Contribute to CI/CD, deployment, and operational best practices within the Microsoft ecosystem.
- Support data governance, documentation, and process improvement efforts.
Hard Skills - Must have:
- Strong hands-on experience with Azure Data Factory.
- Experience working with Microsoft Fabric and/or related Microsoft data platform technologies.
- Strong SQL skills, including query development, transformations, and performance optimization.
- Experience supporting reporting and analytics solutions through Power BI-ready datasets or semantic layers.
- Proficiency in Python for data engineering, automation, or transformation tasks.
- Solid understanding of ETL/ELT concepts, data integration, and data pipeline design.
- Experience working with relational databases such as SQL Server, Azure SQL, PostgreSQL, or similar.
- Knowledge of cloud-based data engineering practices within Azure environment.
Hard Skills - Nice to have/It's a plus:
- Experience with Microsoft Fabric workloads such as Data Factory, Lakehouse, Warehouse, or Dataflows.
- Experience with Power BI development, dashboarding, or performance tuning.
- Familiarity with data modeling concepts for analytics and reporting.
- Experience with CI/CD and DevOps practices in Azure-based environments.
- Exposure to data governance, security, and access management in Microsoft data platforms.
- Experience working in consulting environments or with distributed cross-functional teams.
Soft Skills / Business Specific Skills:
- Strong analytical and problem-solving skills.
- Ability to work effectively in cross-functional and distributed teams.
- Clear communication skills, with the ability to explain technical concepts to non-technical stakeholders.
- Proactive mindset with a strong sense of ownership.
- Commitment to delivering high-quality, reliable data solutions.
Skills Required
- Strong hands-on experience with Azure Data Factory
- Experience working with Microsoft Fabric and/or related Microsoft data platform technologies
- Strong SQL skills, including query development, transformations, and performance optimization
- Experience supporting reporting and analytics solutions through Power BI-ready datasets or semantic layers
- Proficiency in Python for data engineering, automation, or transformation tasks
- Solid understanding of ETL/ELT concepts, data integration, and data pipeline design
- Experience working with relational databases such as SQL Server, Azure SQL, PostgreSQL, or similar
- Knowledge of cloud-based data engineering practices within Azure environment
What We Do
Allata (pronounced a-ley-ta) is a strategy, architecture and enterprise-level application development company focused on helping clients enhance or scale business opportunities, create efficiencies and automate processes through custom technologies. We are building a different kind of firm – focused on doing exciting, transformational work for great clients and bringing caring and dedicated people to make our clients goals a reality. Our vision is to build an energized group of talented professionals that can stand strong on their own but work better as a networked team. We enable business agility at the intersection of people, process, and technology. We provide solutions and expert services to assist businesses to become more nimble, transformative, and disruptive in their respective industries. We define vision, strategy, and value creation models for shaping strategic product designs, managing, and transforming enterprise delivery. Just as strongly as we care about our clients, we feel that it is important to give back to the community and non-profits that we are passionate about. Every month, Allata donates 2% of our net income to a charitable cause our team believes in. We live by our mantra: Family comes first, clients are king, we take great care of our people.
