Job Description
Overview:
We are seeking a skilled Data Analyst to join our team. As a Data Analyst, you will play a pivotal role in ensuring the integrity, quality, and usability of our data assets. You will be responsible for collecting, cleansing, and preparing data to create a solid foundation for analysis and decision-making. The ideal candidate will have a strong understanding of data cleansing techniques, proficiency in data manipulation tools, and a passion for transforming raw data into actionable insights.
Responsibilities:
Collaborate with cross-functional teams to understand data requirements and objectives.
Collect, cleanse, and validate data from various sources to ensure accuracy and consistency. Develop and implement data cleaning processes to identify and resolve errors, duplicates, and inconsistencies in datasets.
Create and maintain data dictionaries, documentation, and metadata to facilitate data understanding and usage.
Design and execute data transformation and normalization processes to prepare raw data for analysis.
Design, standardize, and maintain data hierarchy for business functions within the team. Perform exploratory data analysis to identify trends, patterns, and outliers in the data.
Develop and maintain automated data cleansing pipelines to streamline the data preparation process.
Provide insights and recommendations to improve data quality, integrity, and usability.
Stay updated on emerging trends, best practices, and technologies in data cleansing and data management.
Qualifications
Qualifications:
Bachelor’s degree required in computer science, Statistics, Mathematics, or related field.
Proven experience (2 years) as a Data Analyst, Data Engineer, or similar role, with a focus on data cleansing and preparation.
Competencies:
Strong analytical and problem-solving skills with the ability to translate business requirements into technical solutions.
Proficiency in Power Query (M Language, DAX) for data transformation and cleansing within Microsoft Excel and Power BI environments.
Proficiency in SQL and data manipulation tools (e.g., Python and R).
Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
Experience with ERP systems, particularly JDE (JD Edwards), and familiarity with its data structures and modules for sales orders related tables.
Experience working with large-scale datasets and data warehousing technologies (e.g., iSeries IBM).
Attention to detail and a commitment to data accuracy and quality.
Excellent communication and collaboration skills with the ability to work effectively in a team environment.
Additional Information
Why work for Cornerstone Building Brands?
The US base salary range for this full-time position is $85,000 to $95,000 + medical, dental, vision benefits starting day 1 + 401k and PTO. Our salary ranges are determined by role, level, and location. Individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process. (Full-time is defined as regularly working 30+ hours per week.)
Our teams are at the heart of our purpose to positively contribute to the communities where we live, work and play. Full-time* team members receive** medical, dental and vision benefits starting day 1. Other benefits include PTO, paid holidays, FSA, life insurance, LTD, STD, 401k, EAP, discount programs, tuition reimbursement, training, and professional development. You can also join one of our Employee Resource Groups which help support our commitment to providing a diverse and inclusive work environment.
*Full-time is defined as regularly working 30+ hours per week. **Union programs may vary depending on the collective bargaining agreement.
All your information will be kept confidential according to EEO guidelines