The Technical Data Analyst is a new position and is responsible for supporting data collection, data storage, and data mining necessary for analytics and reporting. This position will collaborate with internal stakeholders to capture requirements, design, create, document, and fulfill requests for on-going and/or ad- hoc reports, dashboards, and scorecards. The Technical Data Analyst will ensure data integrity by implementing quality assurance practices, gathering, and entering missing data, and resolving any anomalies. The Technical Data Analyst will identify areas of improvement in data collection processes or systems and make recommendations to correct any deficiencies. The goal for the Technical Data Analyst role is for it to grow into a full Data Architect role.
This position will directly handle the following responsibilities: - Performing analyses on large datasets to identify spending trends, savings opportunities, and general decision support.
- Generating reports from primary and secondary sources, ensuring the upkeep of databases and data systems
- Detect, examine, and decode trends or patterns within intricate datasets
- Employ statistical techniques to scrutinize data and produce actionable business insights
- Develop SQL reporting databases, data marts, and measure library to support data collection and data mining necessary for analytics and reporting
- Assist with developing data modeling and is responsible for data acquisition, access analysis, archive, recovery, load design and implementation
- Coordinates new data developments to ensure consistency with existing warehouse structure
- Assist with the development, implementation and maintenance of front-end presentation (dashboards), automated report solutions and other BI solutions to support tactical and strategic reporting needs of the organization
- Assist in identification of data integrity problems and recommends solutions
GENERAL SUMMARY PRINCIPLE DUTIES AND RESPONSIBILITIES - Strong data and analytic skills, with the ability to maintain high data integrity
- Knowledge and experience with business intelligence and analytics platforms
- Excellent problem-solving skills, including overcoming challenges and demonstrating the ability to use sound judgement without supervision
- Extensive project management skills with ability to work independently with little supervision
- Demonstrates openness to new organizational structures, procedures, and technology
- Willingness to learn new skills, techniques, change current responsibilities as necessary, and be open to other ideas
- Approaches a complex task or problem by breaking it down into its component parts and considering each part in detail. Identifies features, parameters, or issues important to a situation or decision
- Advanced working knowledge of the following applications: Excel (VBA), BI and analytics tools (Power BI, Tableau, etc.)
- Advanced working knowledge of building data environments (Azure DevOps) from concept, along with ETL processes.
- Proven methods for ensuring data accuracy and cleanliness
- Excellent verbal and written communication skills required
- Ability to interact professionally and work collaboratively with wide range of professionals, both within and outside of the organization
- Good presentation skills
- Ability to explain data and results to groups with different skill levels/understanding, tailoring presentations to different audiences
- Four-year college degree required
- At least 4 years of experience in analytical setting field
Additional Details - Mostly remote / home-based. Local office available and typical to an office environment, sometimes works near moving mechanical parts and with a moderate noise level. Occasional overnight travel, as required
- Occasionally stands and sits. Sometimes walks and reaches. Frequently talks or listens. Sometimes lifts 10-25 pounds. Closer distance, color and peripheral vision, depth perception, and ability to adjust focus required. Extended exposure to computer monitors and extensive keyboarding required.
- Must have ability to work independently, and to organize and coordinate multiple activities. Must work well under pressure of changing priorities and tight deadlines. Remains flexible and adapts to frequently changing needs of the organization. Establishes priorities and maintains workload to ensure timely completion of projects.
- May involve use of personal vehicle (mileage reimbursement provided).
- May require early morning or evening work, depending on meetings and events scheduled.
- This job description is a general description of the essential job functions. It is not intended to describe all the duties this position may perform, and other duties can be assigned as necessary.
The above is a general description of the essential job functions. It is not intended to describe all the duties this position may perform.