Data Engineer II - Information Technology

Position Description Minimum Education Bachelor's degree or equivalent experience Minimum Experience 3 Summary Assists with designing and implementing data management infrastructure. Contributes to building and maintaining data management systems that combine core data sources into data repositories to enable reporting/visualization and analysis of data. Assists with writing or improving code to handle complex data processing tasks. Assists with product development of internal systems, tools, and platform. With regular direction, identifies key opportunities for improvement and technical/process enhancement to increase operational efficiencies. Helps to explore and query datasets, cleans, and transforms data, and may develop dashboards and visualizations. Has an intermediate ability to use tools and technologies that protect the security of Board data. Duties And Responsibilities • With regular guidance, influences building and architecting next generation data management platforms on a group of core technologies. Contributes to developing, maintaining, and optimizing data management solutions that ensure high availability of data availability, data scalability, data quality, data integrity and data security. Contributes to exploring new datasets, promoting data discovery and understanding, revising existing data and building and maintaining data views and aggregate data series of low complexity. Helps to query datasets and cleans/transforms data of low complexity. • Has an intermediate understanding of new/key technologies and platforms and how to incorporate third party APIs and open source/reusable components. Uses intermediate knowledge of new/key technologies to begin to influence the implementation of innovative solutions. • Contributes to utilizing lean and agile software development practices such as test-driven development, refactoring, continuous integration, and deployment, version control, and simple design to create quality, reusable- code. Assists with writing or improving code to handle complex data processing tasks, or rewriting old processes written in older languages. Contributes to collecting ongoing data updates from external sources to establish and maintain software code used to convert raw data into usable formats. • With regular guidance, creates and maintains programs and processes necessary to provide data for production and research. Contributes to implementing processes and programs that monitor data quality, logging and responding to production issues, and ensures production data is always accurate and available for key stakeholders/customers and business processes that depend on it. • Assists with product development of internal systems, tools and platforms supporting operational capabilities. Contributes to transitioning existing products out of legacy technology platforms. May contribute to creating new products as ad hoc requests arise. • Assists with integrating data from multiple sources to employ simple features of integration technologies. Contributes to developing recommendations and providing guidance related to data integration strategy in order to meet future reporting and analytic needs. • With regular guidance, influences the designing, constructing, and implementing of a database system to meet strategic needs. Contributes to building data management systems that combine core data sources into data repositories to enable reporting and analysis of data. Builds up skills related to developing and maintaining data pipelines that ingest data from a wide variety of structured, semi-structured, and unstructured data formats. • With regular direction, identifies key opportunities for improvement and technical/process enhancement to increase operational efficiencies, address future technological needs, and reduce costs associated with the use of internal tools. • Assists with safeguarding digital data throughout its entire lifecycle to protect it from corruption, theft, or unauthorized access. Has an intermediate ability to use tools and technologies that protect data in transit and/or at rest through processes like data masking, encryption, and redaction of sensitive information. Contributes to setting access permissions. • Utilizes foundational to intermediate knowledge of key components of cloud computing and one or more cloud technology platforms. Assists with evaluating use cases to determine which cloud tools and services best fit a client’s needs. • Contributes to gathering and analyzing various quantitative and qualitative data to provide useful information and actionable recommendations to clients. Based on data analysis, helps to illustrate and report data findings using intermediate knowledge of visual charts, figures, tables, and dashboards to tailor findings to specific audiences. • Develops knowledge and awareness of and adheres to applicable governing standards. • Assists with governing large volumes of both structured and unstructured data. Contrib