MS BI Data Architect
Q1 Technologies, Inc
**
Aurora, Illinois
Basic
Posted about 10 hours ago
MS BI Data Architect
Remote
Full Time
o Strong foundation in MS SQL server
o Create complex SQL queries, view, Stored procedure etc. in SQL server.
o Design and implement robust ETL using SSIS.
o Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
o Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
o Optimize data models for performance, ensuring efficient data retrieval and processing.
o Develop advanced DAX formulas and Power Query transformations to create complex calculations and data transformations .
o Understanding and support existing reports in SSRS and developing new reports.
o Domain knowledge of metal and manufacturing industry is a big plus
o Strong analytical and problem-solving skills.
o Excellent communication and presentation skills, with the ability to convey technical concepts to non-technical audiences.
o Ability to work effectively both independently and as part of a team
Remote
Full Time
o Strong foundation in MS SQL server
o Create complex SQL queries, view, Stored procedure etc. in SQL server.
o Design and implement robust ETL using SSIS.
o Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
o Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
o Optimize data models for performance, ensuring efficient data retrieval and processing.
o Develop advanced DAX formulas and Power Query transformations to create complex calculations and data transformations .
o Understanding and support existing reports in SSRS and developing new reports.
o Domain knowledge of metal and manufacturing industry is a big plus
o Strong analytical and problem-solving skills.
o Excellent communication and presentation skills, with the ability to convey technical concepts to non-technical audiences.
o Ability to work effectively both independently and as part of a team
Azure Data Architect with Databricks Expertise
PeopleNTech LLC
**
Alexandria, Virginia
Basic
Posted about 10 hours ago
Role : Azure Data Architect with Databricks Expertise
Location : Iselin, NJ (Hybrid)
Rate: $75/hr to $77/hr
Experience : 15+
Job Summary:
We are seeking highly skilled Azure Data Architect with strong expertise in SQL, Python, Datawarehouse, Cloud ETL tools to join our data team. The ideal candidate will design, implement and optimize large-scale data pipeline, ensuring scalability, reliability and performance. This role involves working closely with multiple teams and business stakeholders to deliver cutting-edge data solutions.
Key Responsibilities:
- Data Pipeline Development:
- Build and maintain scalable ETL/ELT pipelines using Databricks.
- Leverage PySpark/Spark and SQL to transform and process large datasets.
- Integrate data from multiple sources including Azure Blob Storage, ADLS and other relational/non-relational systems.
- Collaboration & Analysis:
- Work Closely with multiple teams to prepare data for dashboard and BI Tools.
- Collaborate with cross-functional teams to understand business requirements and deliver tailored data solutions.
- Performance & Optimization:
- Optimize Databricks workloads for cost efficiency and performance.
- Monitor and troubleshoot data pipelines to ensure reliability and accuracy.
- Governance & Security:
- Implement and manage data security, access controls and governance standards using Unity Catalog.
- Ensure compliance with organizational and regulatory data policies.
- Deployment:
- Leverage Databricks Asset Bundles for seamless deployment of Databricks jobs, notebooks and configurations across environments.
- Manage version control for Databricks artifacts and collaborate with team to maintain development best practices.
Technical Skills:
- Strong expertise in Databricks (Delta Lake, Unity Catalog, Lakehouse Architecture, Table Triggers, Delta Live Pipelines, Databricks Runtime etc.)
- Proficiency in Azure Cloud Services.
- Solid Understanding of Spark and PySpark for big data processing.
- Experience in relational databases.
- Knowledge on Databricks Asset Bundles and GitLab.
Preferred Experience:
- Familiarity with Databricks Runtimes and advanced configurations.
- Knowledge of streaming frameworks like Spark Streaming.
- Experience in developing real-time data solutions.
Certifications:
- Azure Data Engineer Associate or Databricks certified Data Engineer Associate certification. (Optional)
Senior Data Architect Snowflake / Dimensional Modeling
Expert In Recruitment Solutions
**
Media, Pennsylvania
Basic
Posted about 10 hours ago
Title:Senior Data Architect – Snowflake / Dimensional Modeling
Location: Media, PA - Hybrid – 1–2 days/week onsite
LOCAL CANDIDATES ONLY: Candidates must currently live within 30 miles of Media, PA and be available onsite at Wawa 1–2 days per week.
IMPORTANT – ORIGINAL RESUMES ONLY: Please submit the candidate's original resume exactly as provided by the candidate. Do not add job-description keywords, skills, technologies, or experience to a resume. If I find that a resume has been altered to add experience the candidate does not have, the vendor will be removed from consideration.
Project Details
Seeking a Senior Data Architect to lead the modernization of Wawa's enterprise dimensional data warehouse and analytics environment. The role is heavily focused on Snowflake, Python, Kimball/star-schema dimensional modeling, certified data products, and enterprise analytics architecture.
Key Responsibilities
Location: Media, PA - Hybrid – 1–2 days/week onsite
LOCAL CANDIDATES ONLY: Candidates must currently live within 30 miles of Media, PA and be available onsite at Wawa 1–2 days per week.
IMPORTANT – ORIGINAL RESUMES ONLY: Please submit the candidate's original resume exactly as provided by the candidate. Do not add job-description keywords, skills, technologies, or experience to a resume. If I find that a resume has been altered to add experience the candidate does not have, the vendor will be removed from consideration.
Project Details
- Candidate Radius: Must currently live within 30 miles
Seeking a Senior Data Architect to lead the modernization of Wawa's enterprise dimensional data warehouse and analytics environment. The role is heavily focused on Snowflake, Python, Kimball/star-schema dimensional modeling, certified data products, and enterprise analytics architecture.
Key Responsibilities
- Lead redesign and modernization of enterprise dimensional data warehouses using Kimball/star schema
- Define standards for dimensional modeling, semantic consistency, certified datasets, and reporting structures
- Develop conceptual, logical, and physical enterprise data models
- Architect scalable Snowflake data and transformation solutions
- Establish Python-based data engineering standards and reusable patterns
- Design curated/certified datasets supporting executive dashboards, operational reporting, and self-service BI
- Align KPI definitions, reporting logic, and semantic models across the organization
- Drive data governance, lineage, quality, and consistency
- Provide architecture leadership and mentorship to data engineers/modelers
- Lead modernization roadmaps and improve scalability across the analytics ecosystem
- 8+ years of enterprise data architecture, analytics engineering, or data warehousing experience
- MUST HAVE: Strong Snowflake expertise
- MUST HAVE: Advanced Python development
- MUST HAVE: Deep Kimball/star-schema dimensional modeling experience
- MUST HAVE: Enterprise dashboarding and certified data product experience
- Strong SQL development and optimization
- Experience designing curated reporting layers and semantic models
- Experience supporting Tableau, Power BI, or similar enterprise BI platforms
- Strong communication and stakeholder-management skills
- AWS cloud experience
- Databricks or distributed processing frameworks
- Experience modernizing large enterprise analytics and reporting environments