Data Architect II

Description “We Push the Boundaries of Possibilities for our Communities.” The Data Architect II will assist in the design of our master data set, developing architecture, and troubleshooting data issues. To do well in this role you need a very fine eye for detail, experience as a data analyst, and a deep understanding of the popular data analysis tools and databases. Be part of our innovation- building and delivering a fiber-rich internet connection to people’s doorsteps. What You Will Do: Responsible to evolve the data architecture and data strategies for the company. Design and manage centralized, end-to-end data architecture solutions that are aligned with company budget objectives and with business processes. Design frameworks to track data assets: the flow, usage, and storage of company data. Improve observability of the platform defining relevant KPIs, alarm states, and data service telemetry presentation. Coordinate the build of service required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Snowflake and other ‘big data’ technologies. Coordinate the build of analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics. Coordinate database development standards to ensure that company data is secure across national boundaries through multiple data centers and service provider regions. Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs. Work with data and analytics experts to strive for greater functionality in company data systems. Manage and design the reporting environment, including data sources, security, and metadata. Support initiatives for data integrity and normalization. Design and coordinate a curriculum for coaching and training customers in the use of business intelligence tools to enhance business decision-making capability. Create documentation including requirements, design, and user manuals. Develop standards, policies, and procedures for the form, structure, and attributes of the business intelligence tools and systems. Influences changes to standards when necessary. Coach and review the work of lower-level professionals. Other related duties as assigned. What You will Need: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. A bachelor’s degree in business or related field required. A master’s degree preferred. 8+ years in an analytical position required. Leadership experience preferred. Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Familiarity with data collection software and protocols. SQL Server skills including SQL objects development, performance tuning, data analysis and integration required. Knowledge in technology such as Snowflake, Matillion, and ThoughtSpot are preferred. Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, metadata, dependency, and workload management. A successful history of manipulating, processing, and extracting value from large, disconnected datasets. Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores. Experience supporting and working with cross-functional teams in a dynamic environment. Ability to read code and support applications, reports, and processes. A collaborative working style and strong attention to detail. Effective time management with the ability to work independently, manage multiple tasks, set priorities, and meet deadlines. Consistent exercise of independent judgment and discretion in matters of significance. Strong analytical, written, verbal and presentation skills, including the ability to articulate ideas and suggestions clearly and effectively. Prolonged periods of sitting at a desk and working on a computer. Required to use close vision and be able to focus. Upon job offer, must be able to pass a background check and a drug test prior to employment. Salary Range: $81,000 to $115,000 Why Work at Bluepeak? Competitive Compensation + Annual Bonus Eligibility Comprehensive Benefits Package, Including Medical, Dental, Vision, Life, and 401(k) Generous Vacation and Paid Sick Time + Paid Holidays and Personal Days Professional Development with an Emphasis on Internal Promotion Employee Discounts on Bluepeak Services, Including Internet Progressive and inclusive work culture in which our team has the flexibility, support, and resources to be successful in their careers About Us We believe that the size of the city shouldn’t determine the quality of the technology. That’s why we are building for you: Faster, more reliable, and without the things that get in the way of great service—like red tape, hidden fees, and slow response times. And with up to 5 gigabits of speed for residential customers and 10 gigabits for businesses, we are whole new ballgame- from internet to TV, to connecting every device in your home, to powering your business, we’re not only providing the best fiber connections in your community, but we’re also meeting the growing needs for how you live. Bluepeak provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)