Be an early applicantLess than 25 applicants

Company

Constellation · 21 hours ago

Principal Data Solutions Architect

Warrenville, IL

Full-time

Remote

Senior Level, Lead/Staff

$153K/yr - $170K/yr

10+ years exp

Maximize your interview chances

EnergyNatural Resources

Comp. & Benefits

Insider Connection @Constellation

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Design and implement scalable data architectures, including conceptual, logical, and physical models, to meet business objectives and support data-driven decision-making across the organization.

Lead the development and optimization of data pipelines and data warehousing solutions, ensuring data accuracy, consistency, and accessibility for reporting and business intelligence.

Collaborate with business and IT teams to translate business needs into comprehensive data solutions, aligning them with strategic goals while maintaining high data quality, integrity, and security.

Establish and enforce data governance practices to ensure compliance with regulatory standards and industry best practices, while fostering a culture of data stewardship and responsibility.

Stay informed about emerging data technologies, tools, and trends, recommending and implementing innovative solutions to enhance organizational data capabilities and business insights.

Mentor and guide cross-functional teams in the design and implementation of data solutions, including data platforms, ensuring they provide actionable and valuable insights for business users.

Continuously review and optimize existing data systems, identifying opportunities for improvement in efficiency, performance, and user satisfaction, while mitigating potential risks and ensuring project success.

Communicate data strategies and complex technical concepts effectively to both technical and non-technical stakeholders, ensuring alignment with business needs and fostering strong collaboration across teams.

Promote a data-driven culture by educating stakeholders on best practices for data management, reporting tools, and leveraging data insights to support strategic business decisions.

Ensure all data solutions adhere to enterprise architecture frameworks, promoting consistency, scalability, and ongoing development while supporting the growth and development of data teams.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data architectureMicrosoft AzureData governanceData modelingData engineeringETL pipelinesBig Data technologiesData securityData profilingData catalogingData Dictionary maintenanceAzure Machine LearningProject management

Required

Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.

10+ years of experience in IT, with at least 5 years in data architecture, data engineering, or similar role. Proven expertise in designing and delivering large-scale data solutions.

Hands-on experience with Microsoft Azure services, including Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and other Azure data components.

Extensive expertise in data architecture, including data modeling, ETL pipelines, data lakes, and business intelligence solutions, with proficiency in Big Data technologies (e.g., Hadoop, Spark, Kafka) and both relational and NoSQL databases (e.g., SQL Server, MongoDB), along with a strong understanding of Data Lake, Data Mart, DataMesh, and Data Hub concepts.

Proficiency in data modeling for both OLTP and OLAP systems, and familiarity with data formats such as Avro and Parquet.

Ability to define enterprise-level data standards and contribute to the selection of appropriate tools.

Solid understanding of data governance, data security best practices, and cybersecurity fundamentals in the context of cloud-based and enterprise data systems.

Experience in data profiling and data cataloging to ensure high-quality, well-structured data. Ability to maintain up-to-date Data Dictionaries in a disciplined manner.

Hands-on experience with data modeling tools such as Erwin, Power Designer, or similar platforms for creating and managing complex data models.

Experience in analyzing functional and non-functional business requirements and translating them into technical data requirements.

Proven ability to lead cross-functional teams, manage large-scale projects, and collaborate with senior leadership to define and align data strategies with business goals.

Excellent communication skills to convey complex technical concepts to both technical and business stakeholders. Strong consulting and negotiation skills with internal teams and external vendors.

Preferred

Master's Degree

Familiarity with data governance best practices, including data privacy laws (e.g., GDPR, CCPA), and the ability to ensure data security through encryption, access controls, and auditability.

Expertise in optimizing Azure data solutions for performance, scalability, and cost-efficiency, including performance tuning and troubleshooting complex data systems.

Experience with Azure Machine Learning is a plus.

Benefits

Competitive compensation and benefits

Bonus program

401(k) with company match

Employee stock purchase program

Comprehensive medical, dental and vision benefits

Robust wellness program

Paid time off for vacation, holidays, and sick days

Company

Constellation

Glassdoor

3.8

A Fortune 200 company headquartered in Baltimore, Constellation Energy Corporation (Nasdaq: CEG) is the nation’s largest producer of clean, carbon-free energy and a leading supplier of energy products and services to businesses, homes, community aggregations and public sector customers across the continental United States, including three fourths of Fortune 100 companies.

Founded in 1999

Baltimore, Maryland, USA

10001+ employees