CPI Security Senior Analytics Engineer in Charlotte, North Carolina
CPI is focused on building upon its existing Data and Analytics capabilities so we can intertwine data into every key decision and be able to keep close track of business performance and customer satisfaction. We are looking for a Senior Analytics Engineer whose main responsibility will be to collect and manage data for analytics, build visualizations for executive to track their KPIs and other key metrics, as well as make recommendations based on data to the business leaders. The value of this role is its proactive and accurate delivery of analytical data, reports, and actionable analysis. The Data and Analytics team is looking for someone who is curious about data insights and using that curiosity to make our business more successful.
What’s In It For You!
Aggressive pay and the opportunity to work for an iconic brand
Great medical, dental, vision, short- & long-term disability and life insurance options
Company paid holidays, floating holiday, and paid time off (PTO)
401(k) plan with competitive company match
Education assistance – we encourage and support our employees who want to improve their skills and further their education
Engaging and fun company culture that’s made up of a diverse group of people
Volunteer and community engagement opportunities. CPI partners with organizations that share our mission to save and improve lives, particularly focusing on underserved communities.
Talk about perks! An on-site café, coffee/smoothie bar, walking trail, basketball court, and state-of-the-art fitness facility with a dedicated Fitness Director
Birthday and Work Anniversary Rewards, PLUS a Rolex watch at 10 years of service!
Understanding key sources of data and their impacts to the business at a detailed, granular level
Creating analytical datasets through transformational queries and integrations that are both purposeful and performant, suitable for use in automations, and in some instances in a near-real-time demand scenario
Building interactive dashboards and reports that are thoughtfully designed, easily consumed, aesthetically pleasing, and actionable for both desktop and mobile formats
Delivering analyses, both static and dynamic (i.e., presentations and reports) in order to communicate concepts, foster understanding, drive adoption, and gain trust in the data
Maintaining a habit of frequent engagement with business stakeholders and key information consumers, to develop a deep understanding of the “what, why, how, and when” behind every analysis request, as well as seeking feedback post-delivery
5+ years of data engineering experience on backend systems through Microsoft SQL Server
Proficiency in producing data oriented around measures and dimensions
Advanced proficiency with joins and grouping, in respect to data granularity
Output validation and troubleshooting
3+ years of data integrations experience using ETL tools, preferably SQL Server Integration Services (SSIS)
2+ years of dynamic report creation experience using platforms such as Tableau (preferred), Salesforce (preferred), Power BI, SSRS, or equivalent
Demonstrated ability to optimize performance of queries according to SQL best practices
3+ years of experience with Microsoft Excel as both a data endpoint and analysis workspace
Strong oral and written communication skills to effectively deliver messages to a wide range of audiences - from executive to technical
Innovative and strategic mindset with a focus on teamwork and collaboration.
Competencies and Characteristics (Core):
Business Acumen - knowledgeable in current and possible future policies, practices, trends, technology and information regarding data, analytics and business intelligence. Understands the purpose and stakeholders of practices, policies, procedures and systems.
Managing Vision and Purpose – Communicates a compelling and inspired vision or sense of core purpose; talks beyond today; talks about possibilities; is optimistic; creates mileposts and symbols to rally support behind the visions; makes the vision shareable by everyone; can inspire and motivate.
Strategic Agility - Strong strategic analytical skills with the ability to develop creative approaches to communications and problem solving, anticipating future impact and issues.
Presentation Skills - translates complex data analysis into actionable, comprehensible material for diverse audiences in all formats, including formal presentations to large and/or senior teams, as well as informal one-on-one updates
Managing and Measuring Work -establishes clear objectives and measures for self and others. Monitors and reports on progress and results. Sets benchmarks and ensures accountability.
Customer Focus - Is dedicated to meeting the needs of internal and external customers. Gets first-hand internal customer information and uses it to improve processes and deliverables.
Analytical Thinking: Must have the ability to scrutinize and dissect facts and concepts in order to better understand an entire situation
Action Oriented: Must enjoy environments possessing great challenge and requiring diligent work to accomplish deadline-oriented tasks
Time Management: Must be able to maintain focus, obtain goals and complete tasks in a timely and effective manner
Understanding Others: Must be able to recognize and appreciate the intricacies of how different teams function, as well as their intentions, needs and values, and is able to utilize this knowledge to better partner with and motive them
Written Communication: Must be able to write clearly and succinctly in a variety of settings and styles, while consistently conveying messages in a way that creates the desired impact
Connect With Us!
Don't see a career opportunity today?Click HERE (https://careers-cpisecurity.icims.com/connect?back=intro&in_iframe=1&hashed=-625971529) to enroll in our job alerts to stay up-to-date with CPI Careers.
CPI Security does not discriminate against applicants on the basis of race, religion, color, national origin or ancestry, sex, sexual orientation, gender identity, pregnancy, age, veteran status, uniformed service member status, physical or mental disability, genetic information, or other protected status as defined by local, state, or federal law, as applicable.
Job Locations US-NC-Charlotte
Category Information Technology
Type Full Time