Database Administrator & Power BI Data Analyst
Frisco, Texas, United States
NWH Overview:
NWH, founded in 1967, has become the leading manufacturer and supplier of hardwood lumber to North America, Europe, and Asia. With an unwavering focus on simplifying the customer experience, NWH serves the furniture, flooring, cabinet, molding, and millwork industries with 14+ hardwoods species from the major U.S. growing regions as well as imported plywood and exotic lumber. The company operates over 40 manufacturing and warehousing facilities across the country including sawmills, concentration yards and distribution facilities using innovative technologies to streamline the procurement process for customers. NWH supplies only sustainable, high-quality hardwoods to protect our resources today and for future generations. For more information, please visit nwh.com.
Position Summary:
We are seeking a dual-skilled professional to join our IT team as a Database Administrator and Power BI Data Analyst. This role involves the function of maintaining and optimizing our numerous databases, as well as creating and managing SQL reports, Power BI reports and dashboards to support data-driven decisions across the organization. This role will report to the Director of IT Infrastructure Operations and be based remotely.
Key Responsibilities and Duties:
Database Management
- Administer, maintain, and implement policies and procedures to ensure the security and integrity of NWH databases.
- Perform database tuning, monitoring, and performance optimization to ensure efficient operation.
- Implement data models, database designs, data access, and table maintenance codes.
- Resolve database performance issues, capacity issues, replication, and other distributed data issues.
- Conduct regular system audits to ensure compliance with established standards and policies.
- Optimize and consolidate existing databases to ensure optimal system and storage performance
- Manage database access permissions and privileges.
- Develop, manage, and test backup and recovery plans.
Data Analysis
- Develop and maintain SQL reports that enable end users to access data via Excel and to create dynamic visual reports and dashboards using Power BI.
- Translate business needs into technical specifications and design analytical reports.
- Work with stakeholders to identify business requirements and opportunities for data-driven decision-making.
- Analyze data to identify trends, patterns, and insights; make recommendations to optimize business processes.
- Maintain and support data analytics platforms (e.g., Power BI) and monitor data integrity.
Basic Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, Data Engineering or a related field or 5 years equivalent experience.
- Highly proficient in SQL with a strong understanding of data backup, recovery, security, and integrity protocols.
- Proficiency in Microsoft Power BI Desktop and Power BI Service, Power Query, SSIS & SSRS, DAX, and data modeling concepts are required.
- Experience managing and maintaining a Data Warehouse & Data Cubes
Preferred Qualifications:
- Certifications such as Microsoft Certified Database Administrator or Microsoft Power BI certification.
- Experience with cloud services (AWS, Microsoft Azure).
- Familiarity with additional programming languages and APIs.
- Knowledge of Windows Server environments.
Perks & Benefits:
- Medical Plans/Dental Coverage/Vision Coverage
- Prescription Plans
- Life Insurance
- Short-Term Disability Benefit
- Voluntary Long-Term Disability Benefit
- 401k Retirement Saving with Company Match
- Health Saving Account (HSA)
- Employee Assistance Program
- Employee Engagement Center Support
- Paid Time Off and Paid Holidays
- Employee Engagement Events and Activities
- Employee Referral Bonus (No cap)
Additional Information:
NWH is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, age, sexual orientation, national origin, disability, or protected veteran status.
Location: Remote
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs AWS Azure Computer Science CX Data analysis Data Analytics Data warehouse Engineering Excel Power BI Security SQL SSIS
Perks/benefits: 401(k) matching Career development Health care Insurance Salary bonus Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Data Engineer II jobs
- Open Business Intelligence Developer jobs
- Open BI Analyst jobs
- Open Principal Data Scientist jobs
- Open Data Scientist II jobs
- Open Business Data Analyst jobs
- Open Business Intelligence Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Science Intern jobs
- Open Lead Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Software Engineer, Machine Learning jobs
- Open Azure Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Marketing Data Analyst jobs
- Open Manager, Data Engineering jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Analyst II jobs
- Open Product Data Analyst jobs
- Open ETL Developer jobs
- Open Data management-related jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Privacy-related jobs
- Open Data pipelines-related jobs
- Open ML models-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open Business Intelligence-related jobs
- Open PyTorch-related jobs
- Open LLMs-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open CI/CD-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Git-related jobs