We are seeking a motivated and skilled Data Architect to join our dynamic Project & Process Controls team. In this role, you will help manage and optimize our data infrastructure, develop ETL processes, and create insightful data visualizations that support decision-making across the organization. This is an excellent opportunity for a passionate individual to grow their skills in a fast-paced and challenging environment.
Duties
Design, build, and maintain scalable ETL processes using Azure Data Factory and other Azure services.
Develop and optimize SQL queries for data extraction and manipulation in SQL Server.
Collaborate with cross-functional teams to gather data requirements and ensure data quality.
Create and maintain APIs for data integration and sharing across various platforms.
Develop interactive dashboards and visualizations using Power BI to present data insights.
Perform data analysis using Excel to support project management and operational efficiency.
Document data Architecting processes and maintain best practices for data management.
Troubleshoot and resolve data-related issues in a timely manner.
Required Skills and Qualifications Technical Skills
Data Modeling: Designing logical and physical data models to structure data efficiently.
Database Design: Expertise in relational and NoSQL databases, including schema design and optimization.
SQL Proficiency: Strong command of SQL queries for data manipulation and analysis.
ETL Processes: Understanding of Extract, Transform, Load (ETL) procedures for data integration.
Data Warehousing: Knowledge of data warehouse architecture and design principles.
Big Data Technologies: Familiarity with big data platforms like Hadoop and Spark.
Cloud Computing: Understanding of cloud-based data storage and processing services.
Data Visualization: Ability to present data insights through visual tools.
Soft Skills
Communication: Effectively communicating complex data concepts to both technical and non-technical stakeholders.
Collaboration: Working effectively with cross-functional teams including developers, data engineers, and business analysts.
Problem-Solving: Analyzing complex data issues and proposing solutions
Critical Thinking: Evaluating data quality and identifying potential data risks
Leadership: Guiding data strategy and influencing decision-making
Develop and optimize SQL queries for data extraction and manipulation in SQL Server.
Collaborate with cross-functional teams to gather data requirements and ensure data quality.
Create and maintain APIs for data integration and sharing across various platforms.
Develop interactive dashboards and visualizations using Power BI to present data insights.
Perform data analysis using Excel to support project management and operational efficiency.
Document data Architecting processes and maintain best practices for data management.
Troubleshoot and resolve data-related issues in a timely manner.
About Bernards
Established in 1974, Bernards is a growth-oriented Employee-Owned multidisciplinary commercial builder and construction management company delivering technical expertise and outstanding construction services to developers, corporations, educational institutions, and public agencies for projects ranging in size from $5 million to over $500 million. The most significant disciplines in which Bernards projects are focused in, Healthcare, K - 12/Higher Education, Government, Entertainment, Mixed-Use, Residential, and Retail, and more.
Aligning with our mission of building a better experience for our customers, industry partners, and Employee-Owners, Bernards continuously builds its premier contractor status by exhibiting core values of mutual respect, integrity, serving others, and continuous improvement, daily.
As an Employee-Owner, you'll experience competitive pay and enjoy comprehensive benefits that include:
Medical, Dental, and Health Insurance
Stock Interest in the Employee Ownership Plan
Health Savings Account
Flexible Spending Account
Employer Paid Life Insurance
401(k) with employer match
Open Personal Time Off
Sick Time
Paid Holidays
Tuition Reimbursement
Employee Referral Bonus
Employee Assistance Program
Flexible Work Hours
Bernards is an equal opportunity employer that strives to attain and retain, top diversified talent in the construction industry. All qualified individuals will receive consideration for employment without regard to race, color, age, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, genetic information, or any other criteria protected by federal, state, or local law.
For candidates that need reasonable accommodations during the application process, or to perform essential functions of this role, please contact Recruiting@bernards.com.