Data Modeling Analyst jobs in Saint Louis, MO

Do you have strong analytical skills? Do you have the ability to harness logic and reasoning to identify complex relationships. Do you thrive in a fast paced environment and are you looking to join a growing and dynamic team? If the answer is, "Yes!" then we have an exciting, long-term opportunity for you. Who are we? We are ARCO, a Family of Construction Companies.

We are looking for a passionate Data Analyst to join our team. This role will have exposure to all areas of the business and interact with key stakeholders. This person must have the ability to manage multiple projects/deadlines and enjoy working in a fast paced environment.

We are dedicated to the well-being of our associates and are proud to be consistently recognized as a Best Place to Work. Our compensation and benefits package not only supports our associates and their families but benefits local communities and communities around the world.

• Industry-leading performance-based bonus program
• Employee Stock Ownership Plan (ESOP)
• Traditional and Roth 401k
• Tuition reimbursement for associates
• Scholarship for associates’ children up to $28,000 per child
• 1-month paid sabbatical after every five years of employment, plus $5,000 for travel
• 1-week paid volunteer leave each year
• 100% charitable match
• Medical, dental, and vision insurance coverage
• 100% paid 12-week maternity leave

At ARCO, our first core value is to treat people fairly and do the right thing. We are committed to building and sustaining a culture that supports diversity and inclusion. We are proud to be a drug-free workplace and an equal opportunity employer, and all qualified applicants will receive consideration for employment.

From recruiting, training, and hiring practices to selecting our subcontractors, we understand that diversity of all those involved in the construction process enhances our ability to deliver the best solutions to our customers. We hire the best and the brightest from across the country – constructing a team of experts in architecture, design, engineering, project management, and business services.

• Present data to business users to help them make better and more informed decisions
• Partner closely with business users to discover information needs: data, reports, and analyses
• Have a general understanding of the construction industry and how data can be leveraged to improve processes
• Translate business questions into reporting/analytical requirements , preferably MVP.
• Coordinate with IT team to maintain data warehouse applications and packages across active environments
• Validate and reconcile data across all relevant systems
• Responsible for feature delivery in the data warehouses and communication with the functional FP&A, ARCO cohort specific FP&A and accounting teams as applicable
• Work directly with Data & Analytics Center of excellence team to make sure systems are functioning in accordance with financial requirements and SLA’s
• Maintain key processes used to support the consolidation and financial reporting for the business
• Document current processes and controls, new system requirements and the creation of applicable testing scenarios for enhancements and system updates
• Lead integrations and perform validations from source systems and ensure data flows downstream as the need arises.
• Implement policies and procedures that will improve the overall operation and efficiency of the systems, department and Company
• Conduct business impact assessments
• Liaise with internal ARCO’s functional team and business partners to resolve issues and prioritize systems fixes/improvements with the Finance & Accounting processes .

• Ability to thrive in an agile team environment
• Proven ability to effectively communicate with associates of all levels of the organization
• Bachelor’s degree in business, finance, or an equivalent program
• Strong understanding of cost accounting
• 2-5 years of experience in data analysis using common reporting tools
• Advanced Excel experience (pivot table, v-lookups)
• Construction industry experience is considered a plus
• Experience with SQL, SQL Server Management Studio is considered a plus
• Experience working with Microsoft PowerBI or similar analytics platform
• Desire to learn and develop Business Intelligence data visualization skills (may include DAX syntax)
• Experience navigating a highly matrixed environment to achieve department goal.
• Excellent verbal and written communication skills.
• Broad knowledge of data warehousing concepts such as data modelling, star schemas, and ETL